N4 Billing supports EDIFACT standard INVOIC message, release D & version 95B.
This Invoice Message (INVOIC) permits the transfer of data to Billing Customers to transmit the invoice information (Invoice (Line) Items, charges, tariffs, tax information and totals).
This specification provides the definition of the Billing invoice message (INVOIC) to be used in Electronic Data Interchange (EDI) between Billing Customer and N4 Billing Application.
The following sections of this document explain how INVOIC message is handled in N4 Billing and scope of its implementation.
In a terminal, an invoice (or invoices) is generated. Then this invoice information can be sent to customer through EDI Jobs defined.
An INVOIC EDI may contain:
Invoice Main Information (Customer Information, totals)
Line Items (Item descriptions, line item charges and totals)
Tax information
Tariff Information
INVOIC Outbound Supported Segments
Following table illustrates the segments of EDIFACT standard INVOIC D 95B message & scope of each segment in N4. Not used segments were not mentioned in this table.
|
Segment |
Data Element |
Component Element |
Description |
Qualifier |
N4 Billing Fields / Notes |
|---|---|---|---|---|---|
|
UNB |
S001 |
0001 |
Syntax Identifier |
"UNOA" |
|
|
|
|
0002 |
Syntax Version Number |
"1" |
|
|
|
S002 |
0004 |
Sender Identification |
|
Interchange Sender Id if exists, else Interchange Sender |
|
|
|
0007 |
Sender Identification Qualifier |
|
Interchange Sender Qualifier |
|
|
S003 |
0010 |
Recipient Identification |
|
Interchange Recipient Id if exists, else Interchange Recipient |
|
|
|
0007 |
Recipient Identification Qualifier |
|
Interchange Recipient Qualifier |
|
|
S004 |
0017 |
Date of Preparation |
|
YYMMDD |
|
|
|
0019 |
Time of Preparation |
|
HHMM |
|
|
0020 |
|
Interchange Control Reference |
|
Interchange: Interchange Number |
|
UNG |
|
|
|
|
Not Used |
|
UNH |
0062 |
|
Message Reference Number |
|
Billing Transaction: Message Reference Number |
|
|
S009 |
0065 |
Message Type Identifier |
"INVOIC" |
|
|
|
|
0052 |
Message Type Version Number |
"D" |
|
|
|
|
0054 |
Message Type Release Number |
"95B" |
|
|
|
|
0051 |
Controlling Agency |
"UN" |
|
|
BGM |
C002 |
1001 |
Document Name Code |
"380" |
380: Commercial Invoice |
|
|
1004 |
|
Document Identifier |
|
If the invoice is finalized, then Final Number |
|
|
1225 |
|
Message Function Code |
"64" or "9" |
Invoice Status: |
|
DTM - 3 |
C507 |
2005 |
Invoice Date Time Qualifier |
"3" |
3: Invoice Date Time |
|
|
|
2380 |
Invoice Date |
|
CCYYMMDD |
|
|
|
2379 |
Date or Time Format Code |
"102" |
102: CCYYMMDD |
|
NAD - IV |
3035 |
|
Party Qualifier |
"IV" |
Invoicee |
|
|
C082 |
3039 |
Part Identifier |
|
Invoice Payee Customer: Customer Id |
|
|
C058 |
3124-1 |
Address |
|
Invoice Address: Address Line 1 |
|
|
|
3124-2 |
Address |
|
Invoice Address: Address Line 2 |
|
|
|
3124-3 |
Address |
|
Invoice Address: Address Line 3 |
|
|
C080 |
3036-1 |
Party Name |
|
Invoice Payee Customer: Customer Name |
|
|
C059 |
|
Street |
|
Not Used |
|
|
3164 |
|
City Name |
|
Invoice Address: City |
|
|
C819 |
3229 |
Country Sub Entity |
|
Invoice Address: State |
|
|
3251 |
|
Postcode Identification |
|
Not Used |
|
|
3207 |
|
Country Coded |
|
Invoice Address: Country |
|
MOA-9 (SG9) |
C516 |
5025 |
Monetary Amount Qualifier |
"9" |
9: Amount Due: Invoice: Total Owed |
|
|
|
5004 |
Monetary Amount |
|
Invoice: Total Owed |
|
MOA-39 (SG9) |
C516 |
5025 |
Monetary Amount Qualifier |
"39" |
9: Invoice Total Amount: Invoice: Total Charges |
|
|
|
5004 |
Monetary Amount |
|
Invoice: Total Charges |
|
LOC (SG12) |
3227 |
|
Place Location Qualifier |
"7" |
7: Place of Delivery |
|
|
C517 |
3225 |
Location Identification |
|
Invoice: Facility Id |
|
LIN |
1082 |
|
Line Item |
|
Automatically Generated Sequence |
|
|
1229 |
|
Action Request Coded |
|
Not Used |
|
|
C212 |
7140 |
Item Number Identification |
|
Invoice Charge: Charge Entity Id |
|
IMD |
7077 |
|
|
|
Not Used |
|
|
7081 |
|
|
|
Not Used |
|
|
C273 |
7008-1 |
Item Description |
|
Invoice Charge: Charge Event Type Id |
|
|
|
7008-2 |
Item Description |
|
Invoice Charge: Description |
|
QTY-47 |
C186 |
6063 |
Quantity Details Qualifier |
"47" |
47: Invoiced Quantity |
|
|
|
6060 |
Quantity |
|
Invoice Charge: Quantity |
|
DTM - 1 |
C507 |
2005 |
Date Time Qualifier |
"1" |
1: Service Completion Date Time, Actual |
|
|
|
2380 |
Date |
|
CCYYMMDD |
|
|
|
2379 |
Date or Time Format Code |
"102" |
102: CCYYMMDD |
|
DTM - 475 |
C507 |
2005 |
Date Time Qualifier |
"475" |
1: Service Start Date Time, Actual |
|
|
|
2380 |
Date |
|
CCYYMMDD |
|
|
|
2379 |
Date or Time Format Code |
"102" |
102: CCYYMMDD |
|
MO - 203 |
C516 |
5025 |
Monetary Amount Qualifier |
"203" |
203: Line Item Amount |
|
|
|
5004 |
Monetary Amount |
|
Invoice Charge: Total Charged |
|
PRI |
C509 |
5125 |
Price Information Qualifier |
"INV" |
INV: Invoice |
|
|
|
5118 |
Price Amount |
|
Invoice Charge: Rate Billed |
|
|
|
5375 |
Price Type Code |
"PE" |
PE: Per Each |
|
RFF - AFG |
C506 |
1153 |
Reference Code Qualifier |
"AFG" |
AFG: Tariff Number |
|
|
|
1154 |
Reference Identifier |
|
Charge Tariff: Id |
|
DTM - 7 |
C507 |
2005 |
Date Time Qualifier |
"475" |
7: Effective From Date / Time |
|
|
|
2380 |
Date |
|
CCYYMMDD |
|
|
|
2379 |
Date or Time Format Code |
"102" |
102: CCYYMMDD |
|
ALC-C |
5643 |
|
Allowance or Charge Qualifier |
"C" |
C: Charge |
|
TAX |
C241 |
5153 |
Tax Type |
"OTH" |
OTH: Other |
|
|
C243 |
5278 |
Tax Account Detail |
|
Charge Tax: rate |
|
UNT |
0074 |
|
Number of Segments In the Message |
|
Segment Count: calculated during mapping |
|
|
0062 |
|
Message Reference Number |
|
Billing Transaction : Message Reference Number |
|
UNZ |
0036 |
|
Interchange Control Count |
|
# of Billing Transactions: calculated during mapping |
|
|
0020 |
|
Interchange Control Reference |
|
Interchange: Interchange Number |
INVOIC Outbound - Message Functions
As per EDIFACT standard, INVOIC has various message function codes in BGM segment. But N4 supports only Original & Update function codes.
With INVOIC message, two different types of invoice message can be generated: Draft and Finalized. The BIG segment has the distinction between these two types:
If the invoice is finalized:
DTM-3/2380 (Invoice Date): contains Invoice Finalized Date
BGM/1004 (Invoice Number): contains Invoice Final Number
BGM/1225 (Invoice Status): is mapped to "9" (original)
If the invoice is draft:
DTM-3/2380 (Invoice Date): contains Invoice Created Date
BGM/1004 (Invoice Number): contains Invoice Draft Number
BGM/1225 (Invoice Status): is mapped to "64" (verification)
INVOIC Outbound N4 Billing Built-in Map
N4 Billing serves a built-in map which is used to convert Navis standard release xml into INVOIC EDI message.
Following are the related files, part of N4 application and can be downloaded:
invoic_D_95B.mgt - GoXml map
invoic.dic - Edifact standard dictionary
invoice.xsd - Navis standard xml schema
How To Configure N4 Billing For INVOIC?
N4 Billing needs to be set up to process an outgoing INVOIC message. There are 2 steps to configure INVOIC:
Go to Administration > EDI > Message Types.
Click Add to add a new EDI Message Type.
Edit Values in Required Tab, as shown below:
Click Save.
Click Add in the Message Map Tab.
Edit Map Id, and set Direction to Send, as shown below:
Click on Import DIC, and locate invoic.dic supplied and import it.
Click on Import MGT, and locate invoic_D_95B.mgt supplied and import it.
Click Save.
Go to Administration > EDI > EDI Jobs.
Click Add to add a new EDI Job.
Edit Values in Required Tab, as shown below:
Click Save.
Then whenever this Job is run: the INVOIC message is prepared.
In this Section:
Draft Invoices vs Finalized Invoices 1
Exceptions / Non-Standard Issues 1
Draft Invoices vs Finalized Invoices
N4 Billing prepares INVOIC message for both Draft and Finalized Invoices, please refer to INVOIC Message Functions (on page 1) for detailed information.
Exceptions / Non-Standard Issues
The total amounts used in N4 Billing should be mapped, but there could not be found matching qualifiers for those amounts. Therefore the following qualifiers have been introduced (as non-standard) in the mapping for the MOA segments:
???: Total Charges
???: Total Taxes
???: Total Discounts
???: Total Total
???: Total Credits
???: Total Credit Taxes
???: Total Payments
???: Total Owed
INVOIC EDI with One Invoice and Three Line Item
UNB+UNOA:1+MSC+081224:0204+9829+INVOIC'
UNH+13+INVOIC:D:95B:UN'
BGM+380+1+9'
DTM+3:20070318:102'
NAD+IV'
MOA+9:49.0'
MOA+39:49.0'
LOC+7+LCT'
LIN+1++IMKU2008141'
IMD+++:::STORAGE:5 to 8 days'
QTY+47:5.0'
DTM+1:20070327:102'
DTM+475:20070323:102'
MOA+203:35.0'
PRI+INV:7.0:PE'
RFF+AFG:STAORAGE_GENERAL'
DTM+7:20070315:102'
ALC+C'
TAX++OTH'
LIN+2++IMKU2008141'
IMD+++:::STORAGE:0 to 2 days'
QTY+47:2.0'
DTM+1:20070320:102'
DTM+475:20070319:102'
MOA+203:4.0'
PRI+INV:2.0:PE'
RFF+AFG:STAORAGE_GENERAL'
DTM+7:20070315:102'
ALC+C'
TAX++OTH'
LIN+3++IMKU2008141'
IMD+++:::STORAGE:3 to 5 days'
QTY+47:2.0'
DTM+1:20070322:102'
DTM+475:20070321:102'
MOA+203:10.0'
PRI+INV:5.0:PE'
RFF+AFG:STAORAGE_GENERAL'
DTM+7:20070315:102'
ALC+C'
TAX++OTH'
UNT+000041+13'
UNZ+1+9829'
UNB+UNOA:1+MSC+081224:0204+9829+INVOIC'
UNH+13+INVOIC:D:95B:UN'
BGM+380+1+9'
DTM+3:20070318:102'
NAD+IV'
MOA+9:49.0'
MOA+39:49.0'
LOC+7+LCT'
LIN+1++IMKU2008141'
IMD+++:::STORAGE:5 to 8 days'
QTY+47:5.0'
DTM+1:20070327:102'
DTM+475:20070323:102'
MOA+203:35.0'
PRI+INV:7.0:PE'
RFF+AFG:STAORAGE_GENERAL'
DTM+7:20070315:102'
ALC+C'
TAX++OTH'
LIN+2++IMKU2008141'
IMD+++:::STORAGE:0 to 2 days'
QTY+47:2.0'
DTM+1:20070320:102'
DTM+475:20070319:102'
MOA+203:4.0'
PRI+INV:2.0:PE'
RFF+AFG:STAORAGE_GENERAL'
DTM+7:20070315:102'
ALC+C'
TAX++OTH'
LIN+3++IMKU2008141'
IMD+++:::STORAGE:3 to 5 days'
QTY+47:2.0'
DTM+1:20070322:102'
DTM+475:20070321:102'
MOA+203:10.0'
PRI+INV:5.0:PE'
RFF+AFG:STAORAGE_GENERAL'
DTM+7:20070315:102'
ALC+C'
TAX++OTH'
UNT+000041+13'
UNZ+1+9829'
UNB+UNOA:1++081224:0204++INVOIC'
UNH++INVOIC:D:95B:UN'
BGM+380+1+9'
DTM+3:20070318:102'
NAD+IV'
MOA+9:49.0'
MOA+39:49.0'
LOC+7+LCT'
LIN+4++IMKU2008141'
IMD+++:::STORAGE:5 to 8 days'
QTY+47:5.0'
DTM+1:20070327:102'
DTM+475:20070323:102'
MOA+203:35.0'
PRI+INV:7.0:PE'
RFF+AFG:STAORAGE_GENERAL'
DTM+7:20070315:102'
ALC+C'
TAX++OTH'
LIN+5++IMKU2008141'
IMD+++:::STORAGE:0 to 2 days'
QTY+47:2.0'
DTM+1:20070320:102'
DTM+475:20070319:102'
MOA+203:4.0'
PRI+INV:2.0:PE'
RFF+AFG:STAORAGE_GENERAL'
DTM+7:20070315:102'
ALC+C'
TAX++OTH'
LIN+6++IMKU2008141'
IMD+++:::STORAGE:3 to 5 days'
QTY+47:2.0'
DTM+1:20070322:102'
DTM+475:20070321:102'
MOA+203:10.0'
PRI+INV:5.0:PE'
RFF+AFG:STAORAGE_GENERAL'
DTM+7:20070315:102'
ALC+C'
TAX++OTH'
UNT+000041'
UNZ+1'
INVOIC Outbound Test Instructions
After an invoice is generated/created, and INVOIC configuration is done as described in the N4 Billing configuration, related EDI Job can be executed, and the output EDI is placed in the EDI mailbox.